how to create scalar valued function in sql server.

Question

Anonymous User · Answer

--let’s start querying create a table.
and CREATE TABLE ProductMasters(
and and and and and and  ProductId int IDENTITY(1,1) primary key,
and and and and and and  ProductName nvarchar(max) ,
and and and and and and  Price decimal(18, 2)and  ,
and and and and and and  CategoryId intand and 
and )
and --We will now create a scalar function, which returns the
total of price filtered by a givenand 
category . Write the following code in your query pad – 
and Create function fnGetTotatPrice
(and  
and @categoryId int
)
returns decimal(10,2)
As
Begin return ( select sum(price) from ProductMasters where CategoryId=@categoryId) 
end
--The above function returns an integer
value. To test this function, we will write some code as shown below – 
select dbo.fnGetTotatPrice(2) as price

forum

how to create scalar valued function in sql server.

Anonymous User

Can you answer this question?

1 Answers

Liked By